105 messages in org.oasis-open.lists.office-formulaRe: [office-formula] Semantics
FromSent OnAttachments
46 earlier messages
Eike RathkeFeb 28, 2006 11:52 am 
Bastian, WaldoFeb 28, 2006 12:24 pm 
Eike RathkeFeb 28, 2006 12:26 pm 
Eike RathkeFeb 28, 2006 12:30 pm 
Daniel CarreraFeb 28, 2006 1:01 pm 
David A. WheelerFeb 28, 2006 1:11 pm 
Bastian, WaldoFeb 28, 2006 2:57 pm 
Tom MetcalfFeb 28, 2006 3:05 pm 
robe...@us.ibm.comFeb 28, 2006 4:28 pm 
Tomas MecirMar 1, 2006 12:26 am 
Tomas MecirMar 1, 2006 12:35 am 
Tomas MecirMar 1, 2006 12:43 am 
Daniel CarreraMar 1, 2006 2:08 am 
Eike RathkeMar 1, 2006 3:47 am 
Tomas MecirMar 1, 2006 3:59 am 
Eike RathkeMar 1, 2006 5:05 am 
Tomas MecirMar 1, 2006 5:30 am 
robe...@us.ibm.comMar 1, 2006 5:32 am 
Daniel CarreraMar 1, 2006 6:14 am 
David A. WheelerMar 1, 2006 7:06 am 
robe...@us.ibm.comMar 1, 2006 7:15 am 
Eike RathkeMar 1, 2006 7:50 am 
Eike RathkeMar 1, 2006 8:21 am 
Eike RathkeMar 1, 2006 8:24 am 
Eike RathkeMar 1, 2006 8:29 am 
Tomas MecirMar 1, 2006 8:32 am 
Tomas MecirMar 1, 2006 8:40 am 
Richard KernickMar 1, 2006 10:43 am 
Richard KernickMar 1, 2006 10:43 am 
robe...@us.ibm.comMar 1, 2006 12:35 pm 
Richard KernickMar 1, 2006 2:08 pm 
Daniel CarreraMar 1, 2006 2:27 pm 
David A. WheelerMar 1, 2006 2:38 pm 
robe...@us.ibm.comMar 1, 2006 3:44 pm 
David A. WheelerMar 1, 2006 4:09 pm 
Eike RathkeMar 2, 2006 12:23 pm 
Tomas MecirMar 3, 2006 12:32 am 
Richard KernickMar 4, 2006 12:58 pm 
Tomas MecirMar 5, 2006 2:52 am 
David A. WheelerMar 5, 2006 11:03 am 
Daniel CarreraMar 6, 2006 1:19 am 
Tomas MecirMar 6, 2006 1:40 am 
Eike RathkeMar 6, 2006 8:14 am 
Tomas MecirMar 6, 2006 8:19 am 
Tomas MecirMar 6, 2006 8:21 am 
Eike RathkeMar 6, 2006 8:26 am 
Eike RathkeMar 6, 2006 8:42 am 
robe...@us.ibm.comMar 6, 2006 10:03 am 
Daniel CarreraMar 6, 2006 12:20 pm 
robe...@us.ibm.comMar 6, 2006 12:49 pm 
Richard KernickMar 6, 2006 4:37 pm 
Daniel CarreraMar 7, 2006 1:15 am 
Tomas MecirMar 7, 2006 1:21 am 
Richard KernickMar 7, 2006 3:00 pm 
Eike RathkeMar 8, 2006 9:30 am 
Eike RathkeMar 8, 2006 9:48 am 
Eike RathkeMar 8, 2006 9:53 am 
Eike RathkeMar 8, 2006 10:02 am 
Eike RathkeMar 8, 2006 10:16 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [office-formula] SemanticsActions...
From:robe...@us.ibm.com (robe@us.ibm.com)
Date:Mar 6, 2006 12:49:58 pm
List:org.oasis-open.lists.office-formula

OK. So someone who has a process that takes a table of conversion factors from the web and pastes these into a spreadsheet and then uses automatic string->number conversions to do a calculation would create a spreadsheet which would work in one locale, but would break in another.

This makes me think that we shouldn't spend to much time on this area. Specify how it works today in OO (or Excel or whatever) and immediately deprecate this feature in the grammar. I think we want to be promoting a file format which encourages and supports the creation of formulas which are invariant under locale changes. Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. We should probably make a whole list of stuff which we'll need to define for legacy application compatibility, but which we'll want to immediately deprecate.

-Rob

Daniel Carrera <dani@zmsl.com> wrote on 03/06/2006 03:23:18 PM:

Interesting debate.

How hard is it to come up with a real-world example of a formula which would give a different result based on the locale of the user who opens it? Not just a different presentation, but an actual different meaning. If this can ever happen, it would be a bad thing, IMHO.

I must not be understanding this question because it seems too easy. For example, the exchange rate from Euros to Canadian dollars is 1,369 if you are in Germany but that will give you the wrong result if you use that string in Canada.